﻿
/****** Object:  Table [dbo].[Feedback]    Script Date: 08/12/2009 16:56:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Feedback](
 [FeedbackId] [bigint] IDENTITY(1,1) NOT NULL,
 [CMSPageId] [bigint] NOT NULL,
 [Moderated] [int] NOT NULL,
 [UserId] [varchar](40) NULL,
 [Name] [varchar](250) NULL,
 [Email] [varchar](250) NULL,
 [Website] [varchar](250) NULL,
 [Score] [numeric](18, 0) NOT NULL,
 [Comments] [ntext] NULL,
 [DateCreated] [datetime] NOT NULL,
 [DateModerated] [datetime] NULL,
 [Timestamp] [timestamp] NOT NULL,
 [AdditionalField1] [varchar](8000) NULL,
 [AdditionalField2] [varchar](8000) NULL,
 [AdditionalField3] [varchar](8000) NULL,
 [AdditionalField4] [varchar](8000) NULL,
 [AdditionalField5] [varchar](8000) NULL
 CONSTRAINT [PK_Feeback] PRIMARY KEY CLUSTERED 
(
 [FeedbackId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF